2 2
Hi! Thanks for viewing this video! In this extract we will learn how to create a doughnut chart. Let's go to the sheet "Doughnut chart". Here we 3 3
have the 4 4
same table as the one that we saw in our previous sheet. 5 5
Let's suppose that we would like to give a good graphical representation of the breakdown of 6 6
"Total Revenues" within a single financial period. Say FY13. 7 7
The doughnut chart is excellent for such purposes. 8 8
I'll select the figures of the three revenue components for FY13. 9 9
Go to "Insert", 10 10
where we have "Other charts", and here we can select "Doughnut chart" from the menu. 11 11
Let's format it in a similar way as the previous chart. 12 12
We can right-click on the chart and select "Arial" 8 as font. 13 13
The next step will be to right-click on the chart and select "Format chart area", where we'll remove the fill and the border color of the chart. 14 14
Better. Let's reduce its size to Quarter page by grabbing its angle and adjusting until we have the right proportions. 15 15
We are missing the labels for the three categories of revenues. 16 16
Through a right-click on the chart, we can choose "Select Data" where we can assign the three horizontal axis labels 17 17
in the following way. 18 18
In order to add a title to the chart, we have to go to the "Chart tools" menu. 19 19
Once we click on the chart and it appears on the menu bar, 20 20
we have to click on "Chart title" 21 21
and select the type of title that we need. 22 22
In our case I'll pick a title, which is a above the chart. 23 23
Let's adjust its size, font 24 24
and position - "Arial", font size 9, 25 25
and I'd like the title to be on the left. 26 26
Let's name the chart in the same way as the one on the right - "Breakdown of revenues in FY13". 27 27
I'll modify the colors of the chart in order to improve its appearance. 28 28
Excel usually does a poor job when assigning automatic colors. 29 29
Let's add data lables in the same way we did for the chart that we saw before - right-clicking on one of the chart series and clicking 30 30
"Add data labels". 31 31
As usual, I'll format them in white and will put them in bold. 32 32
Do you notice how there are some steps, which I always repeat when formatting each chart? I believe that 33 33
you will have them too, as this will be your preferred way of doing things. 34 34
Nurturing such routines is good, as they allow you to be fast and really consistent. 35 35
Now the only difference between the two charts is the box in the middle showing the total amount of the item, which is broken down into 36 36
percentages. Let's add such a box to our new chart. 37 37
I'll go to"Insert", select "Text box", 38 38
and will type within that text box the total amount of the item. 39 39
We should have it in "Arial" as well. 40 40
I'll adjust the size of the box and once we are ready we can include it in our chart. 41 41
It is very important to use precisely the following procedure: 42 42
cut the text box, select the chart and paste the text box within it. I am doing it with Ctrl + V. 43 43
This mechanism turns the text box into one of the charts' components. 44 44
If I change the chart's position within the sheet, 45 45
we can see that that text box changes its position together with the chart. This is how we create a doughnut chart. 46 46
Thanks for watching!